UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rGPLK2u88HoATwqhT02ED+HuErRSY/XvCls6VAvhet8='
WHERE
key_id = '41c2149f5d621e60a80f4cfcf817a6fe92ac771ad574a4dbd27993c1fb65dc6f'
AND (
token = 'rGPLK2u88HoATwqhT02ED+HuErRSY/XvCls6VAvhet8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)