UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MwhuYkz1MCTzuQPgZ5pq9tAK7y6QXIkwOoTL8jLmqH0='
WHERE
key_id = 'd24b7501ab5713fd0d8a3634d06b062134c14bc07e72a60901d88a1fdd123dd2'
AND (
token = 'MwhuYkz1MCTzuQPgZ5pq9tAK7y6QXIkwOoTL8jLmqH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)