UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cQ1lq7tnsupzrCNoD9xA0hW2tZMk6x3dVUQ3S/w3WI4='
WHERE
key_id = '4a1a85386a313048045546639fd913a28ca5eb0e6b1ea1859cd0935b45aa397f'
AND (
token = 'cQ1lq7tnsupzrCNoD9xA0hW2tZMk6x3dVUQ3S/w3WI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)