UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+DbbeeX6iX8apIfavPPwF69043+IwDucju9CQGj6tE8='
WHERE
key_id = 'e7577184d6555512f6fc753c133c64771c597f8b250e7b148ab270ca8be12a4b'
AND (
token = '+DbbeeX6iX8apIfavPPwF69043+IwDucju9CQGj6tE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)