UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'teK1gJSVH5GxasRS7pUiK5dTqkVvA9Gp4Qe0xbPXDwg='
WHERE
key_id = 'a9863b70a70a53cbd1955738c26f78457ae5ac903613dd76a4d131c4c836c459'
AND (
token = 'teK1gJSVH5GxasRS7pUiK5dTqkVvA9Gp4Qe0xbPXDwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)