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