UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BVA1PIKA0sAAv2Lx7tLf+uzRfbk1Q6p9psX5g5I26Qs='
WHERE
key_id = 'e8d52c1750476bd50865593b545b4ad089cf6c9b67be7767432774f80bfe5016'
AND (
token = 'BVA1PIKA0sAAv2Lx7tLf+uzRfbk1Q6p9psX5g5I26Qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)