UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dRuB0f69y08j5kImYuPT9P5DiVH/UysxhzrFPF+aiSo='
WHERE
key_id = 'c103e3f1d1e5f381e543ede53c1b35ce8c74aac40c0eec831f338b6d03b58a2a'
AND (
token = 'dRuB0f69y08j5kImYuPT9P5DiVH/UysxhzrFPF+aiSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)