UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K9a+qUG15UpvdylWSz2vYbUYPZDc5aLOn9qJqwqcdTs='
WHERE
key_id = '09c2ca7745954fd567ef673f3f96b8faf09aadf57c188abd926ce602010d5b60'
AND (
token = 'K9a+qUG15UpvdylWSz2vYbUYPZDc5aLOn9qJqwqcdTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)