UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HWieDzqpKmNZeFV6PT6VYxt8Sdf7g7J7a5Wk8uOSqas='
WHERE
key_id = 'e42595967f3d581f58670cb4f759e7b2a149df553a3e34673b4a62532d923a7f'
AND (
token = 'HWieDzqpKmNZeFV6PT6VYxt8Sdf7g7J7a5Wk8uOSqas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)