UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2074+tLj26lw5pWL4+jhJIySo04X2NLD2iWmuKw3a88='
WHERE
key_id = '6b478da9042829814a59c84ce86d554572b9325839f916368e1bfefea089b27c'
AND (
token = '2074+tLj26lw5pWL4+jhJIySo04X2NLD2iWmuKw3a88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)