UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6CY2dD8308FkL97lw0syqjHTjhOIDK0SR3YZbiD7vjc='
WHERE
key_id = '8f156805258a71006f0049fb80410bfabf06fa5c209847be11ac3df99be586ee'
AND (
token = '6CY2dD8308FkL97lw0syqjHTjhOIDK0SR3YZbiD7vjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)