UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHCcDLhAWegcfT0OGUlL9RFtD6JQ8T3UhOmU7JYqhpU='
WHERE
key_id = '8b0dc3b4e11b4a285891d84ac47c8af1e5fa8cd9c0d6b7468e4e41e84393775c'
AND (
token = 'tHCcDLhAWegcfT0OGUlL9RFtD6JQ8T3UhOmU7JYqhpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)