UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HDvW/hYkw8zzETfIbk08q8HIH0gnN9s6Mj8WKa18Mco='
WHERE
key_id = '5818717b4c32f11c646a672387d8ff3a233e4b01b7d9ef0a2a5ff3c383366141'
AND (
token = 'HDvW/hYkw8zzETfIbk08q8HIH0gnN9s6Mj8WKa18Mco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)