UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thUYzlM3NCIkkJqHxHeAfPhH996oxqU4JTM7BY7QmgA='
WHERE
key_id = '10ec6e78bba2f277d00f518d4846ed647b5e947ed7e310b2a87d9f93d8d7747c'
AND (
token = 'thUYzlM3NCIkkJqHxHeAfPhH996oxqU4JTM7BY7QmgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)