UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGENCKj6aRM0WzEKX1r+wI7P2BKwLecspl/Llpn1+MM='
WHERE
key_id = 'c4fca0745939682a4eede19080e523fab6f3256b047b9cd9aadef611c2a3ff85'
AND (
token = 'pGENCKj6aRM0WzEKX1r+wI7P2BKwLecspl/Llpn1+MM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)