UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9zPaWC9xbiF+bOTfcZDA59ww5gVW8sRQ2kxOURKUIRc='
WHERE
key_id = '0563af6d7c537226c866915f3e34af0d0271c4f8f808e0a3e7b42ff2ec1e8f6b'
AND (
token = '9zPaWC9xbiF+bOTfcZDA59ww5gVW8sRQ2kxOURKUIRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)