UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3r8owP6VrCyv+dJuDR1qFNyQtKYzxAypnkn9WTv4bms='
WHERE
key_id = 'ecff4bc52b997764512a0deac8f5d633515f3c3680aa89407a02460b9198fa41'
AND (
token = '3r8owP6VrCyv+dJuDR1qFNyQtKYzxAypnkn9WTv4bms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)