UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4e7kGVWSyGfGuj3rWx729ws08y6kxFoEe4Lg6/Q0tx4='
WHERE
key_id = '10f8f0515280b8eff0360dd3cac387bb46afa266a5e6fa03cf5aad2449cb8088'
AND (
token = '4e7kGVWSyGfGuj3rWx729ws08y6kxFoEe4Lg6/Q0tx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)