UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6dp7dxV4x2SSVwpLguGfRS0ayhgYk7KY10fzTV8tHh0='
WHERE
key_id = 'eaddbc13858fd84d98c1098857ef4779f9d885308c87d96247c4a6615cfb3dc1'
AND (
token = '6dp7dxV4x2SSVwpLguGfRS0ayhgYk7KY10fzTV8tHh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)