UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lBRpUw3lbe+6t5DfT5SuRpJIMTIseMnzY9VMuuG3S98='
WHERE
key_id = 'e75b5e104f5bfe2eea42e7e233bb2bab934f19176951a2f9f3d42e758900de80'
AND (
token = 'lBRpUw3lbe+6t5DfT5SuRpJIMTIseMnzY9VMuuG3S98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)