UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3E4TnH9QSHtiyPmcpX2yoWRWxmvoTTPky0NaXT+bCQo='
WHERE
key_id = 'ae52c47fd0cd4b105cfc71f23072c4e47210d756ff995075e5a84319e94df802'
AND (
token = '3E4TnH9QSHtiyPmcpX2yoWRWxmvoTTPky0NaXT+bCQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)