UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kXw3P7I47s/4bN1zExHUNTLAJiJfcJlEPL/+t+CiAT8='
WHERE
key_id = 'e8b9754f8ac7bcbf9e618104d011c82e93acf330451f2d9760f44df933490315'
AND (
token = 'kXw3P7I47s/4bN1zExHUNTLAJiJfcJlEPL/+t+CiAT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)