UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1wyLpiXDDTfFVio+Wm6pVEsuj+R0BxVxjXe6ZsDY83I='
WHERE
key_id = '12f27e40bd8a92964c4d03d9216b5f2c6616ef184993fb159983f206d684d685'
AND (
token = '1wyLpiXDDTfFVio+Wm6pVEsuj+R0BxVxjXe6ZsDY83I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)