UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gS4DOs9I717tSbdT4YCri9G3gqeYL98CbW1eVis+1io='
WHERE
key_id = '58f0b7a705a0565436f8d938f42b60130e237c6b8df0407c72e7dad9068f220a'
AND (
token = 'gS4DOs9I717tSbdT4YCri9G3gqeYL98CbW1eVis+1io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)