UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0LpB1ZtI6uRAPXATjLH4e5xorFQ9mW+3mFRxSUhkpU='
WHERE
key_id = '9114387d591ad7bb2c989a7e631abcb5f16598f7d75315ee23c250469a7d23e0'
AND (
token = 'X0LpB1ZtI6uRAPXATjLH4e5xorFQ9mW+3mFRxSUhkpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)