UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hrYOJ7figJLvLGXtytZpxk4XTtZNuOoo1fbRhEaJAbY='
WHERE
key_id = '86e5bcbed1f9ebe1c9374f364318732ca9c6e21336e4bbfb1224db3ce9cd96fc'
AND (
token = 'hrYOJ7figJLvLGXtytZpxk4XTtZNuOoo1fbRhEaJAbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)