UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ej6oA8VZMZQ4uHGFAC8Z53muZYLhojF4SiCqgu85FTw='
WHERE
key_id = '29417286b9c27fbd7c8334453388f052eccf7e8e11899e11e7e5d913f50106b2'
AND (
token = 'ej6oA8VZMZQ4uHGFAC8Z53muZYLhojF4SiCqgu85FTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)