UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q78xe1+oViR+FK7U7Xab590xWJCwfmrun3lwo7NvoVQ='
WHERE
key_id = 'c50c95be7c5922951206fff0a06c1c92aed2d9b776dab27c36b9481ce33b615a'
AND (
token = 'Q78xe1+oViR+FK7U7Xab590xWJCwfmrun3lwo7NvoVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)