UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Ur2f6klcnfpXLaOVC/CFJZYI9+zxEZyvU5WamWPwbU='
WHERE
key_id = 'd0c4f94922f25214350c8f87e1383dc8bbdbc3eacb7292d99712aa06d4ee0455'
AND (
token = '9Ur2f6klcnfpXLaOVC/CFJZYI9+zxEZyvU5WamWPwbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)