UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcUnKpl/WqXqRAilTYqGgzTu5073i7gunKlahZkdtnw='
WHERE
key_id = '4aae16e2fd5d9cb9edf53ed4460cd5dce5598e8a4c34023d9fc22bec1178340e'
AND (
token = 'bcUnKpl/WqXqRAilTYqGgzTu5073i7gunKlahZkdtnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)