UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hOqRAJYcdGRgZMgSXEZISH2Lq2TdPeWXXrFbw1UuIHo='
WHERE
key_id = '0513b248140f2b1857220287863c3cc8ab1168a27b4b3ca76abe1611386c77bc'
AND (
token = 'hOqRAJYcdGRgZMgSXEZISH2Lq2TdPeWXXrFbw1UuIHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)