UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GJ0OgZCsItSr41oYI/On8cAlQyPj/e3pSOcqDyF2c8='
WHERE
key_id = '511e481426d6991fdc2fcf0753bfbd5a89b67074daa5d7d182eea3d7a1af0efb'
AND (
token = '8GJ0OgZCsItSr41oYI/On8cAlQyPj/e3pSOcqDyF2c8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)