UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '71NSYphrfdQnPfSUY3ljNtXUZQtT6VbN/nxs96u4EPk='
WHERE
key_id = 'f27af6cd17dcc89fdf1055a23f13e5f77f08aab2ca74ece95f7a0613056072e7'
AND (
token = '71NSYphrfdQnPfSUY3ljNtXUZQtT6VbN/nxs96u4EPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)